Google Cloud Platform BigQuery - Query BigQuery Table

Browse: 🏠 · Solutions · Connectors · Methods · Tables · Content · Parsers · ASIM Parsers · ASIM Products · 📊

↑ Back to Content Index

This playbook can be run from incident context manually or from automation rule to query the GCP BigQuery table and enrich the incident with results.

Attribute Value
Type Playbook
Solution Google Cloud Platform BigQuery
Source View on GitHub

Additional Documentation

📄 Source: GCPBigQueryPlaybooks/GCPBigQuery-GetQueryResults/readme.md

GCPBigQuery-GetQueryResults

Summary

This playbook can be run from incident context manually or from automation rule to query the GCP BigQuery table and enrich the incident with query results. The playbook performs following actions:

  1. Runs the SQL query as Query job and gets the result.
  2. Parse the result and format as table.
  3. Add the result as comment to the incident.



Prerequisites

  1. Prior to the deployment of this playbook, GCPBigQuery Logic App Custom Connector needs to be deployed under the same subscription.
  2. Refer to GCPBigQuery Logic App Custom Connector documentation for deployment instructions.

Deployment instructions

  1. To deploy the Playbook, click the Deploy to Azure button. This will launch the ARM Template deployment wizard.
  2. Fill in the required parameters:
    • Playbook Name
    • Custom Connector Name
    • GCP Project ID
    • SQL Query String

Deploy to Azure Deploy to Azure

Post-Deployment instructions

a. Authorize connections

Once deployment is complete, authorize each connection.

  1. Select the Microsoft Sentinel connection resource
  2. Click Edit API connection blade
  3. Click Authorize/Provide credentials
  4. Click Save
  5. Repeat these steps for other connections

b. Configurations in Sentinel

  1. In Microsoft Sentinel, configure the automation rule/analytical rule to trigger the playbook. Check the documentation to learn more about automation rules.

c. Assign Playbook Microsoft Sentinel Responder Role

  1. Select the Playbook (Logic App) resource
  2. Click on Identity Blade
  3. Choose System assigned tab
  4. Click on Azure role assignments
  5. Click on Add role assignments
  6. Select Scope - Resource group
  7. Select Subscription - where Playbook has been created
  8. Select Resource group - where Playbook has been created
  9. Select Role - Microsoft Sentinel Responder
  10. Click Save

References

Browse: 🏠 · Solutions · Connectors · Methods · Tables · Content · Parsers · ASIM Parsers · ASIM Products · 📊

↑ Back to Playbooks · Back to Google Cloud Platform BigQuery